First need to join up the real property data (Open Baltimore) the sales data (provided by Steve, and with deed dates from January 1, 2010 through October 2018) so we have a neighborhood for as many sales as we can.
1,153 sales didn’t match to a block-lot in the real property table, which means that the block-lot jointly was not in the real prop table.
Also, there are about 16,000 properties in the real prop table that don’t have a neighborhood.
So after joining we end up with 9,428 sales that don’t have a neighborhood.
The real property table also gives if it is principal residence or not, so we’ll also filter for the sales that are for principal residences.
Neighborhood Summary Table, 2015-2017
We have 16062 samples to work with that are in 2015-2017, have a neighborhood, were an arms-length sale, and are the principal residence.
Which neighborhoods have less than 20 sales meeting the criteria?
84 neighborhoods have less than 20 sales meeting the criteria. We’ll exclude them going forward so we have a reasonable sample size.
Criteria & Results
There are 239 sales that meet the following criteria:
- Deed date was between January 1, 2018 and October 5, 2018
- Arms-length sale
- Principal residence
- Neighborhood had at least 20 sales
- 98th percentile for sales prices for their neighborhood.
(If this yield isn’t high enough we can bump it down to the 95th percentile.)
LS0tDQp0aXRsZTogIlJlY2VudCBTYWxlcyBPdXRsaWVycyINCmF1dGhvcjogIkp1c3RpbiBFbHN6YXN6LCBNYXlvcidzIE9mZmljZSBvZiBJbm5vdmF0aW9uIg0KZW1haWw6ICJqdXN0aW4uZWxzemFzekBiYWx0aW1vcmVjaXR5LmdvdiINCmRhdGU6ICJUaHVyc2RheSwgRmVicnVhcnkgMjgsIDIwMTkiDQpvdXRwdXQ6DQogIGh0bWxfbm90ZWJvb2s6DQogICAgY29kZV9mb2xkaW5nOiBoaWRlDQogICAgZmlnX2hlaWdodDogNQ0KICAgIGZpZ193aWR0aDogMTANCiAgICB0b2M6IHllcw0KICAgIHRvY19kZXB0aDogMg0KLS0tDQoNCmBgYHtyIHNldHVwLCBpbmNsdWRlID0gRkFMU0UsIGVjaG8gPSBGQUxTRSwgbWVzc2FnZSA9IEZBTFNFLCBjYWNoZSA9IFRSVUV9DQprbml0cjo6b3B0c19jaHVuayRzZXQoZWNobyA9IEZBTFNFLCB3YXJuaW5nID0gRiwgbWVzc2FnZSA9IEYsIGluY2x1ZGUgPSBULA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgZmlnLndpZHRoID0gMTAsIGZpZy5oZWlnaHQgPSA1KQ0KYGBgDQoNCg0KYGBge3J9DQpzb3VyY2UoIi4uL3NyYy8wMF9pbml0aWFsaXplLlIiKQ0Kc2FsZXMgPC0gbG9hZF9zYWxlc19kYXRhKGxvYWQuY2FjaGUgPSBUKQ0KDQpsaWJyYXJ5KFJTb2NyYXRhKQ0KbGlicmFyeShzcCkNCmxpYnJhcnkobGVhZmxldCkNCg0KcmVhbC5wcm9wLnVybCA8LSAiaHR0cHM6Ly9kYXRhLmJhbHRpbW9yZWNpdHkuZ292L3Jlc291cmNlLzZhY3QtcXp1eS5qc29uIg0KcmVhbC5wcm9wIDwtIHJlYWQuc29jcmF0YShyZWFsLnByb3AudXJsLCBhcHBfdG9rZW4gPSBWQVJTJFNPQ1JBVEFfVE9LRU4pDQoNCmhvb2RzIDwtIGdldF9uZWlnaGJvcmhvb2RfYm91bmRhcmllcygpDQpgYGANCg0KRmlyc3QgbmVlZCB0byBqb2luIHVwIHRoZSByZWFsIHByb3BlcnR5IGRhdGEgKFtPcGVuIEJhbHRpbW9yZV0oW2h0dHA6Ly9kYXRhLmJhbHRpbW9yZWNpdHkuZ292L0ZpbmFuY2lhbC9SZWFsLVByb3BlcnR5LVRheGVzLzI3dzktdXJ0dnRvKSkgdGhlIHNhbGVzIGRhdGEgKHByb3ZpZGVkIGJ5IFN0ZXZlLCBhbmQgd2l0aCAqKmRlZWQgZGF0ZXMgZnJvbSBKYW51YXJ5IDEsIDIwMTAgdGhyb3VnaCBPY3RvYmVyIDIwMTgqKikgc28gd2UgaGF2ZSBhIG5laWdoYm9yaG9vZCBmb3IgYXMgbWFueSBzYWxlcyBhcyB3ZSBjYW4uDQoNCmBgYHtyfQ0Kc2FsZXMgPC0gc2FsZXMgJT4lIHJlbmFtZShzYWxlcy5ibG9jayA9IEJsb2NrLCBzYWxlcy5sb3QgPSBMb3QpDQpyZWFsLnByb3AgPC0gcmVhbC5wcm9wICU+JSByZW5hbWUocmVhbC5ibG9jayA9IGJsb2NrLCByZWFsLmxvdCA9IGxvdCkNCmBgYA0KDQpgYGB7cn0NCnJlYWwucHJvcCA8LSByZWFsLnByb3AgJT4lDQogIG11dGF0ZShyZWFsLmJsb2NrLmNsZWFuID0gZ3N1YigiXjArIiwgIiIsIHJlYWwuYmxvY2spLA0KICAgICAgICAgcmVhbC5sb3QuY2xlYW4gPSBnc3ViKCJeMCsiLCAiIiwgcmVhbC5sb3QpKQ0KDQpzYWxlcyA8LSBzYWxlcyAlPiUNCiAgbXV0YXRlKHNhbGVzLmJsb2NrLmNsZWFuID0gZ3N1YigiXjArIiwgIiIsIHNhbGVzLmJsb2NrKSwNCiAgICAgICAgIHNhbGVzLmxvdC5jbGVhbiA9IGdzdWIoIl4wKyIsICIiLCBzYWxlcy5sb3QpKQ0KYGBgDQoNCmBgYHtyfQ0Kc2FsZXMgPC0gc2FsZXMgJT4lDQogIGxlZnRfam9pbihyZWFsLnByb3AsIA0KICAgICAgICAgICAgYnkgPSBjKCJzYWxlcy5ibG9jay5jbGVhbiIgPSAicmVhbC5ibG9jay5jbGVhbiIsDQogICAgICAgICAgICAgICAgICAgInNhbGVzLmxvdC5jbGVhbiIgPSAicmVhbC5sb3QuY2xlYW4iKQ0KICAgICAgICAgICAgKQ0KYGBgDQoNCmBgYHtyfQ0Kc2FsZXMgJT4lIGNvdW50KGlzLm5hKHJlYWwuYmxvY2spLCBpcy5uYShyZWFsLmxvdCkpDQpgYGANCg0KMSwxNTMgc2FsZXMgZGlkbid0IG1hdGNoIHRvIGEgYmxvY2stbG90IGluIHRoZSByZWFsIHByb3BlcnR5IHRhYmxlLCB3aGljaCBtZWFucyB0aGF0IHRoZSBibG9jay1sb3Qgam9pbnRseSB3YXMgbm90IGluIHRoZSByZWFsIHByb3AgdGFibGUuIA0KDQpBbHNvLCB0aGVyZSBhcmUgYWJvdXQgMTYsMDAwIHByb3BlcnRpZXMgaW4gdGhlIHJlYWwgcHJvcCB0YWJsZSB0aGF0IGRvbid0IGhhdmUgYSBuZWlnaGJvcmhvb2QuIA0KDQpgYGB7cn0NCnJlYWwucHJvcCAlPiUgY291bnQoaXMubmEobmVpZ2hib3Job29kKSkNCmBgYA0KDQpTbyBhZnRlciBqb2luaW5nIHdlIGVuZCB1cCB3aXRoIDksNDI4IHNhbGVzIHRoYXQgZG9uJ3QgaGF2ZSBhIG5laWdoYm9yaG9vZC4NCg0KYGBge3J9DQpzYWxlcyAlPiUgY291bnQoIWlzLm5hKG5laWdoYm9yaG9vZCkpDQpgYGANCg0KVGhlIHJlYWwgcHJvcGVydHkgdGFibGUgYWxzbyBnaXZlcyBpZiBpdCBpcyBwcmluY2lwYWwgcmVzaWRlbmNlIG9yIG5vdCwgc28gd2UnbGwgYWxzbyBmaWx0ZXIgZm9yIHRoZSBzYWxlcyB0aGF0IGFyZSBmb3IgcHJpbmNpcGFsIHJlc2lkZW5jZXMuDQoNCmBgYHtyfQ0Kc2FsZXMgJT4lIGNvdW50KHJlc2NvZGUpDQpgYGANCg0KDQojIE5laWdoYm9yaG9vZCBTdW1tYXJ5IFRhYmxlLCAyMDE1LTIwMTcNCg0KYGBge3J9DQptZWV0LmNyaXRlcmlhIDwtIHNhbGVzICU+JQ0KICBmaWx0ZXIoeWVhcihkZWVkLmRhdGUpICVpbiUgYygyMDE1LCAyMDE2LCAyMDE3KSwNCiAgICAgICAgICFpcy5uYShuZWlnaGJvcmhvb2QpLA0KICAgICAgICAgYEhvdyBDb252ZXllZGAgPT0gMSwNCiAgICAgICAgICFncmVwbCgiTk9UIiwgcmVzY29kZSkpICU+JQ0KICBucm93DQpgYGANCg0KV2UgaGF2ZSBgciBtZWV0LmNyaXRlcmlhYCBzYW1wbGVzIHRvIHdvcmsgd2l0aCB0aGF0IGFyZSBpbiAyMDE1LTIwMTcsIGhhdmUgYSBuZWlnaGJvcmhvb2QsIHdlcmUgYW4gYXJtcy1sZW5ndGggc2FsZSwgYW5kIGFyZSB0aGUgcHJpbmNpcGFsIHJlc2lkZW5jZS4NCg0KYGBge3J9DQpzYWxlcy5zdW1tYXJ5LjE1XzE3LmJ5Lmhvb2QgPC0gc2FsZXMgJT4lDQogIGZpbHRlcih5ZWFyKGRlZWQuZGF0ZSkgJWluJSBjKDIwMTUsIDIwMTYsIDIwMTcpLA0KICAgICAgICAgIWlzLm5hKG5laWdoYm9yaG9vZCksDQogICAgICAgICBgSG93IENvbnZleWVkYCA9PSAxLA0KICAgICAgICAgIWdyZXBsKCJOT1QiLCByZXNjb2RlKSkgJT4lDQogIGdyb3VwX2J5KG5laWdoYm9yaG9vZCkgJT4lDQogIHN1bW1hcmlzZShob29kLm4gPSBuKCksDQogICAgICAgICAgICBob29kLm1lYW4gPSBtZWFuKGBTYWxlcyBQcmljZWApLA0KICAgICAgICAgICAgaG9vZC5tZWRpYW4gPSBtZWRpYW4oYFNhbGVzIFByaWNlYCksDQogICAgICAgICAgICBob29kLnN0ZCA9IHNxcnQoc3VtKChgU2FsZXMgUHJpY2VgLWhvb2QubWVhbileMi8oaG9vZC5uLTEpKSksDQogICAgICAgICAgICBob29kLjk1dGggPSBxdWFudGlsZShgU2FsZXMgUHJpY2VgLCBwcm9icyA9IC45NSksDQogICAgICAgICAgICBob29kLjk4dGggPSBxdWFudGlsZShgU2FsZXMgUHJpY2VgLCBwcm9icyA9IC45OCkpDQoNCnNhbGVzLnN1bW1hcnkuMTVfMTcuYnkuaG9vZCAgDQpgYGANCg0KV2hpY2ggbmVpZ2hib3Job29kcyBoYXZlIGxlc3MgdGhhbiAyMCBzYWxlcyBtZWV0aW5nIHRoZSBjcml0ZXJpYT8NCg0KYGBge3J9DQpzYWxlcy5zdW1tYXJ5LjE1XzE3LmJ5Lmhvb2QgJT4lDQogIGZpbHRlcihob29kLm4gPCAyMCkNCmBgYA0KDQo4NCBuZWlnaGJvcmhvb2RzIGhhdmUgbGVzcyB0aGFuIDIwIHNhbGVzIG1lZXRpbmcgdGhlIGNyaXRlcmlhLiBXZSdsbCBleGNsdWRlIHRoZW0gZ29pbmcgZm9yd2FyZCBzbyB3ZSBoYXZlIGEgcmVhc29uYWJsZSBzYW1wbGUgc2l6ZS4NCg0KYGBge3J9DQojIEpvaW4gdGhlIHN1bW1hcmllcyB0byB0aGUgbmVpZ2hib3Job29kIGJvdW5kYXJpZXMNCmhvb2RzQGRhdGEgPC0gaG9vZHNAZGF0YSAlPiUgDQogIGxlZnRfam9pbihzYWxlcy5zdW1tYXJ5LjE1XzE3LmJ5Lmhvb2QsDQogICAgICAgICAgICBieSA9IGMoImxhYmVsIiA9ICJuZWlnaGJvcmhvb2QiKSkNCmBgYA0KDQojIENyaXRlcmlhICYgUmVzdWx0cw0KDQpgYGB7cn0NCnNhbGVzLmhvb2QuOTh0aCA8LSBzYWxlcyAlPiUNCiAgbGVmdF9qb2luKHNhbGVzLnN1bW1hcnkuMTVfMTcuYnkuaG9vZCwNCiAgICAgICAgICAgIGJ5ID0gYygibmVpZ2hib3Job29kIiA9ICJuZWlnaGJvcmhvb2QiKSkgJT4lDQogIGZpbHRlcih5ZWFyKGRlZWQuZGF0ZSkgPT0gMjAxOCwNCiAgICAgICAgIGhvb2QubiA+PSAyMCwNCiAgICAgICAgIGBTYWxlcyBQcmljZWAgPj0gaG9vZC45OHRoLA0KICAgICAgICAgYEhvdyBDb252ZXllZGAgPT0gMSwNCiAgICAgICAgICFncmVwbCgiTk9UIiwgcmVzY29kZSkpICU+JQ0KICBhcnJhbmdlKG5laWdoYm9yaG9vZCkNCg0KcmVzdWx0LnNhbGVzIDwtIG5yb3coc2FsZXMuaG9vZC45OHRoKQ0KYGBgDQoNCioqVGhlcmUgYXJlIGByIHJlc3VsdC5zYWxlc2Agc2FsZXMgdGhhdCBtZWV0IHRoZSBmb2xsb3dpbmcgY3JpdGVyaWE6KioNCg0KLSBEZWVkIGRhdGUgd2FzIGJldHdlZW4gSmFudWFyeSAxLCAyMDE4IGFuZCBPY3RvYmVyIDUsIDIwMTgNCi0gQXJtcy1sZW5ndGggc2FsZQ0KLSBQcmluY2lwYWwgcmVzaWRlbmNlDQotIE5laWdoYm9yaG9vZCBoYWQgYXQgbGVhc3QgMjAgc2FsZXMNCi0gOTh0aCBwZXJjZW50aWxlIGZvciBzYWxlcyBwcmljZXMgZm9yIHRoZWlyIG5laWdoYm9yaG9vZC4NCg0KKElmIHRoaXMgeWllbGQgaXNuJ3QgaGlnaCBlbm91Z2ggd2UgY2FuIGJ1bXAgaXQgZG93biB0byB0aGUgOTV0aCBwZXJjZW50aWxlLikNCg0KYGBge3J9DQpzYWxlcy5ob29kLjk1dGgkbG9uZyA8LSBsYXBwbHkoc2FsZXMuaG9vZC45NXRoJGxvY2F0aW9uLmNvb3JkaW5hdGVzLCBmdW5jdGlvbih4KSB4WzFdKSAlPiUgdW5saXN0KCkNCg0Kc2FsZXMuaG9vZC45NXRoJGxhdCA8LSBsYXBwbHkoc2FsZXMuaG9vZC45NXRoJGxvY2F0aW9uLmNvb3JkaW5hdGVzLCBmdW5jdGlvbih4KSB4WzJdKSAlPiUgdW5saXN0KCkNCmBgYA0KDQpgYGB7cn0NCnNhbGVzLmhvb2QuOTV0aC5nZW8gPC0gc2FsZXMuaG9vZC45NXRoICU+JSBmaWx0ZXIoIWlzLm5hKGxvbmcpKQ0KICANCnNhbGVzLmhvb2QuOTV0aC5nZW8gPC0gU3BhdGlhbFBvaW50c0RhdGFGcmFtZSgNCiAgc2FsZXMuaG9vZC45NXRoLmdlbyAlPiUgc2VsZWN0KGxvbmcsIGxhdCksIA0KICBzYWxlcy5ob29kLjk1dGguZ2VvLA0KICBwcm9qNHN0cmluZyA9IENSUygiK3Byb2o9bG9uZ2xhdCArZGF0dW09V0dTODQgK25vX2RlZnMgK2VsbHBzPVdHUzg0ICt0b3dnczg0PTAsMCwwIikpDQoNCnNhbGVzLmhvb2QuOTV0aC5nZW8gPC0gDQogIHNwVHJhbnNmb3JtKA0KICAgIHNhbGVzLmhvb2QuOTV0aC5nZW8sIA0KICAgIENSU29iaiA9IENSUygiK2luaXQ9ZXBzZzo0MzI2ICtwcm9qPWxvbmdsYXQgK2RhdHVtPVdHUzg0ICtub19kZWZzICtlbGxwcz1XR1M4NCArdG93Z3M4ND0wLDAsMCIpDQogICAgKQ0KDQpgYGANCg0KYGBge3J9DQpzYWxlcy5ob29kLjk4dGgkbG9uZyA8LSBsYXBwbHkoc2FsZXMuaG9vZC45OHRoJGxvY2F0aW9uLmNvb3JkaW5hdGVzLCBmdW5jdGlvbih4KSB4WzFdKSAlPiUgdW5saXN0KCkNCg0Kc2FsZXMuaG9vZC45OHRoJGxhdCA8LSBsYXBwbHkoc2FsZXMuaG9vZC45OHRoJGxvY2F0aW9uLmNvb3JkaW5hdGVzLCBmdW5jdGlvbih4KSB4WzJdKSAlPiUgdW5saXN0KCkNCmBgYA0KDQoNCmBgYHtyfQ0Kc2FsZXMuaG9vZC45OHRoLmdlbyA8LSBzYWxlcy5ob29kLjk4dGggJT4lIGZpbHRlcighaXMubmEobG9uZykpDQogIA0Kc2FsZXMuaG9vZC45OHRoLmdlbyA8LSBTcGF0aWFsUG9pbnRzRGF0YUZyYW1lKA0KICBzYWxlcy5ob29kLjk4dGguZ2VvICU+JSBzZWxlY3QobG9uZywgbGF0KSwgDQogIHNhbGVzLmhvb2QuOTh0aC5nZW8sDQogIHByb2o0c3RyaW5nID0gQ1JTKCIrcHJvaj1sb25nbGF0ICtkYXR1bT1XR1M4NCArbm9fZGVmcyArZWxscHM9V0dTODQgK3Rvd2dzODQ9MCwwLDAiKSkNCg0Kc2FsZXMuaG9vZC45OHRoLmdlbyA8LSANCiAgc3BUcmFuc2Zvcm0oDQogICAgc2FsZXMuaG9vZC45OHRoLmdlbywgDQogICAgQ1JTb2JqID0gQ1JTKCIraW5pdD1lcHNnOjQzMjYgK3Byb2o9bG9uZ2xhdCArZGF0dW09V0dTODQgK25vX2RlZnMgK2VsbHBzPVdHUzg0ICt0b3dnczg0PTAsMCwwIikNCiAgICApDQoNCmBgYA0KDQojIE1hcA0KDQpgYGB7cn0NCmxpYnJhcnkoaHRtbHRvb2xzKQ0KDQpob29kcy5sYWJlbHMgPC0gcGFzdGUwKA0KICBob29kcyRsYWJlbCwNCiAgIjxicj5NZWRpYW4gU2FsZXMsIDIwMTUtMjAxNzogIiwgYXMuY2hhcmFjdGVyKGhvb2RzJGhvb2QubWVkaWFuKQ0KICANCikNCg0Kc2FsZS5sYWJlbHMgPC0gcGFzdGUwKA0KICBzYWxlcy5ob29kLjk4dGguZ2VvJGBIb3VzZSAjYCwgIiAiLA0KICBzYWxlcy5ob29kLjk4dGguZ2VvJGBTdHJlZXQgTmFtZWAsICIgIiwNCiAgc2FsZXMuaG9vZC45OHRoLmdlbyRTdWZmaXgsIA0KICAiPGJyPlNhbGUgUHJpY2UgaW4gMjAxODogIiwgDQogIGFzLmNoYXJhY3RlcihzYWxlcy5ob29kLjk4dGguZ2VvJGBTYWxlcyBQcmljZWApLA0KICAiPGJyPk5ldyBPd25lcjogIiwgc2FsZXMuaG9vZC45OHRoLmdlbyRuZXcub3duZXINCikNCg0KDQpsZWFmbGV0KCkgJT4lDQogIHNldFZpZXcobG5nID0gLTc2LjYsIGxhdCA9IDM5LjMsIHpvb20gPSAxMSkgJT4lDQogIGFkZFByb3ZpZGVyVGlsZXMocHJvdmlkZXJzJFN0YW1lbi5Ub25lckxpdGUpICU+JSANCiAgYWRkUG9seWdvbnMoZGF0YSA9IGhvb2RzLCANCiAgICAgICAgICAgICAgd2VpZ2h0ID0gMiwgDQogICAgICAgICAgICAgIGNvbG9yID0gImJsYWNrIiwNCiAgICAgICAgICAgICAgb3BhY2l0eSA9IDAuNSwNCiAgICAgICAgICAgICAgZmlsbE9wYWNpdHkgPSAwLCANCiAgICAgICAgICAgICAgbGFiZWwgPSB+bGFwcGx5KGhvb2RzLmxhYmVscywgSFRNTCkpICU+JQ0KICBhZGRDaXJjbGVNYXJrZXJzKGRhdGEgPSBzYWxlcy5ob29kLjk4dGguZ2VvLCANCiAgICAgICAgICAgICAgICAgICByYWRpdXMgPSAyLA0KICAgICAgICAgICAgICAgICAgIGxhYmVsID0gfmxhcHBseShzYWxlLmxhYmVscywgSFRNTCkpDQpgYGANCg0KIyBGdWxsIGxpc3QNCg0KYGBge3J9DQpzYWxlcy5ob29kLjk4dGggDQpgYGANCg0KDQo=